﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$UserLoginDBConnection$" type="$UserLoginDbType$" defaultFormatter="bizobj CompanyTreeNode">
  <SqlStatement hasResults="true">
    SELECT t.parentHostId, t.companyId as id, t.parentId FROM CompanyTree  t
    WHERE t.companyId=@parentId
    ORDER BY t.parentHostId,t.parentId,t.companyId
  </SqlStatement>
  <Param name="parentId" type="UniqueIdentifier"/>
</DbDataRequest>